Hệ thống quản lý phương tiện trong PHP

1 <?php
2    
3    $id= $_GET[
'id'];
4
5    $conn=mysqli_connect(
'localhost','root','','vehiclemanagement');
6
7     $sql1=
"SELECT `veh_reg`, `driverid` FROM `booking` WHERE booking_id='$id'";
8     $result1=mysqli_query($conn,$sql1);
9     $row= mysqli_fetch_assoc($result1);
10     $veh_reg=$row[
'veh_reg'];
11     $driverid=$row[
'driverid'];
12 echo $veh_reg;
13 echo $driverid;
14     
15     
16     
17    $sql=
"UPDATE `vehicle` SET `veh_available`='0' WHERE veh_reg='$veh_reg'; UPDATE `driver` SET `dr_available`='0' WHERE driverid='$driverid'; UPDATE `booking` SET `finished`='1' WHERE booking_id='$id'";
18     
//echo $sql;
19    $result=mysqli_multi_query($conn,$sql);
20    
if($result){
21        header(
"Location: bookinglist.php");
22    }
else{
23          echo
"Not freed";
24    }
25    
26 ?>


Gõ tìm kiếm nhanh...